<?php
include('sys_data_fun.php');

$dh = dir(DUODUODATA);
$j=0;
while(($filename=$dh->read()) !== false){
	if ($filename != "." && $filename != ".."){
		$dp=DUODUODATA.'/'.$filename;
		if(judge_empty_dir($dp)!=1){
	        $arr=explode('_',$filename);
	        $time=date('Y-m-d',strtotime($arr[1]));
	        $option_arr[$j]="<option value='$arr[1]'>$time</option>";
		    $j++;
		}
	}
	$b_date=$arr[1];
}
for($i=$j;$i>=0;$i--){
    $option.=$option_arr[$i];
}
$dh->close();

if(!$date){
	$date=$b_date;
}
$bkdir = DUODUODATA."/".$cfg_backup_dir.'_'.$date;

if(!is_dir($bkdir)){
    PutInfo("<font color='red'>您还没有创建备份文件</font>","");
	exit;
}

$filelists = Array();
$dh = dir($bkdir);
$structfile = "没找到数据结构文件";
while(($filename=$dh->read()) !== false)
{
	if(!ereg('php$',$filename))
	{
		continue;
	}
	if(ereg('tables_struct',$filename))
	{
		$structfile = $filename;
	}
	else if( filesize("$bkdir/$filename") >0 )
	{
		$filelists[] = $filename;
	}
}
$dh->close();
mysql_close();
?>
<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>
<title>数据库维护--数据还原</title>
<style>
* {
	font-size: 12px;
	font-family: "宋体";
}

td { line-height: 1.5; }

body {
	font-size: 12px;
	line-height: 1.5;
	font-family: "宋体";
}

form,h1,h2,h3,ul,ol,div{	margin: 0; padding:0;}
.dlg {
	border: 2px solid #749F4D;
	background-color: #F0FAEB;
	padding: 2px;
	width: 360px;
	line-height:160%;
}
</style>
<script language="javascript">
//获得选中文件的数据表
function getCheckboxItem(){
	 var myform = document.form1;
	 var allSel="";
	 if(myform.bakfile.value) return myform.bakfile.value;
	 for(i=0;i<myform.bakfile.length;i++)
	 {
		 if(myform.bakfile[i].checked){
			 if(allSel=="")
				 allSel=myform.bakfile[i].value;
			 else
				 allSel=allSel+","+myform.bakfile[i].value;
		 }
	 }
	 return allSel;
}
//反选
function ReSel(){
	var myform = document.form1;
	for(i=0;i<myform.bakfile.length;i++){
		if(myform.bakfile[i].checked) myform.bakfile[i].checked = false;
		else myform.bakfile[i].checked = true;
	}
}
//全选
function SelAll(){
	var myform = document.form1;
	for(i=0;i<myform.bakfile.length;i++){
		myform.bakfile[i].checked = true;
	}
}
//取消
function NoneSel(){
	var myform = document.form1;
	for(i=0;i<myform.bakfile.length;i++){
		myform.bakfile[i].checked = false;
	}
}
//
function checkSubmit()
{
	var myform = document.form1;
	myform.bakfiles.value = getCheckboxItem();
	return true;
}

</script>
</head>
<body background='img/allbg.gif' leftmargin='8' topmargin='8'>
<table width="99%" border="0" cellpadding="3" cellspacing="1" bgcolor="#D1DDAA">
  <tr>
    <td height="19" colspan="4" background="img/tbg.gif" bgcolor="#E7E7E7">
    	<table width="96%" border="0" cellspacing="1" cellpadding="1">
        <tr>
          <td width="24%"><strong>数据还原</strong></td>
          <td width="76%" align="right">
          <form action="ReData.php" method="get">
          	<b><a href="ChangeDb.php"><u>数据备份</u></a></b>
          	|
          	<b>数据还原</b>
            <select name="date"><?=$option?></select>
            <input type="submit" value="提交" class="coolbg np" />
            </form>
          </td>
        </tr>
      </table>
    </td>
  </tr>
  <form name="form1" onSubmit="checkSubmit()" action="sys_data_done.php" method="post" target="stafrm">
    <input type='hidden' name='dopost' value='redat' />
    <input type='hidden' name='bakfiles' value='' />
    <tr bgcolor="#F7F8ED">
      <td height="24" colspan="4" valign="top">
      	<strong>发现的备份文件 (日期：<?=date('Y-m-d',strtotime($date))?>)</strong>
        <?php if(count($filelists)==0) echo " 没找到任何备份文件... "; ?>
      </td>
    </tr>
    <?php
    for($i=0;$i<count($filelists);$i++)
    {
    	echo "<tr  bgcolor='#FFFFFF' align='center' height='24'>\r\n";
      $mtd = "<td width='10%'>
             <input name='bakfile' id='bakfile' type='checkbox' class='np' value='".$filelists[$i]."' checked='1' />
             </td>
             <td width='40%'>{$filelists[$i]}</td>\r\n";
      echo $mtd;
      if(isset($filelists[$i+1]))
      {
      	$i++;
      	$mtd = "<td width='10%'>
              <input name='bakfile' id='bakfile' type='checkbox' class='np' value='".$filelists[$i]."' checked='1' />
              </td>
              <td width='40%'>{$filelists[$i]}</td>\r\n";
        echo $mtd;
      }else{
      	echo "<td></td><td></td>\r\n";
      }
      echo "</tr>\r\n";
    }
    ?>
    <tr align="center" bgcolor="#FDFDEA">
      <td height="24" colspan="4">
      	&nbsp;
        <input name="b1" type="button" id="b1" onClick="SelAll()" value="全选" />
        &nbsp;
        <input name="b2" type="button" id="b2" onClick="ReSel()" value="反选" />
        &nbsp;
        <input name="b3" type="button" id="b3" onClick="NoneSel()" value="取消" />
     </td>
    </tr>
	  <tr bgcolor="#F7F8ED">
      <td height="24" colspan="4" valign="top">
      	<strong>附加参数：</strong>
      </td>
    </tr>
    <tr  bgcolor="#FFFFFF">
      <td height="24" colspan="4">
        <input name="structfile" type="checkbox" class="np" id="structfile" value="<?php echo $structfile?>" checked='1' />
        还原表结构信息(<?php echo $structfile?>)
        <input name="delfile" type="checkbox" class="np" id="delfile" value="1" />
        还原后删除备份文件 
        <input name="keepdb" type="checkbox" class="np" id="keepdb" value="1" />
        保留现有表结构 
        </td>
    </tr>
    <tr bgcolor="#E3F4BB">
      <td height="33" colspan="4">
      	 &nbsp;<input type="hidden" name="date" value="<?=$date?>" />
      	 <input type="submit" name="Submit" value="开始还原数据" class="coolbg np" />
      </td>
    </tr>
  </form>
  <tr bgcolor="#F7F8ED">
    <td height="24" colspan="4"><strong>进行状态： </strong></td>
  </tr>
  <tr bgcolor="#FFFFFF">
    <td height="180" colspan="4">
    	<iframe name="stafrm" frameborder="0" id="stafrm" width="100%" height="100%"></iframe>
    </td>
  </tr>
</table>
</body>
</html>